To support the activity attachment feature, the following fields in the Activity_Attach table are used:
Column Name |
Data Type/Size |
Description |
---|---|---|
ACTIVITY_SEQN |
long integer |
Used to store a reference to an associated activity record |
FILE_NAME |
varchar (255) |
Attachment's file extension |
FILE_TIMESTAMP |
Datetime |
Date the attachment was last modified |
ATTACH_IMAGE |
image |
File's binary data |
INTENT_TO_EDIT |
varchar (40) |
Indicates whether a user has started an edit operation (Date/Time + "#" + <User ID>) |
READ_ONLY |
Boolean |
Indicates whether the attachment is available for editing by non-administrator users |
10.6 Production Release. Updated 1/18/2006 3:50:35 PM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.